// Adds a Person record.
private static void Add(DbDataAccess dbDataAccess
  , DbColumns dataDefinition)
{
  // Create the list of included columns.
  // This list must not include the database assigned columns
  // or the database assigned columns must have the AutoIncrement
  // value set to "true".
  List<string> columnNames = new List<string>();
  foreach (DbColumn column in dataDefinition)
  {
    if (column.ColumnName != "Id")
    {
      columnNames.Add(column.ColumnName);
    }
  }

  // The inserted columns must not include the DB assigned columns.
  Person dataRecord = new Person()
  {
    Name = "TestName",
    PrincipleFlag = false
  };

  // Create a Data Columns object with the included data definitions
  // and values from the data record.
  var dataColumns = DbCommon.QueryDataColumns(dataRecord, columnList
    , dataDefinition);

  // This code is needed only if there are database assigned columns.
  DbColumns keyColumns = GetKeyColumns(dataRecord, dataDefinition);

  // Create query with columns containing values from the record.
  DbRequest dbRequest = new DbRequest()
  {
    Columns = dataColumns,
    KeyColumns = keyColumns
    QueryType = QueryType.Insert.ToString(),
    TableName = "PersonTest",
  };
  DbResult dbResult = dbDataAccess.Execute(dbRequest);

  if (dbResult != null)
  {
    string sqlStatement = dbResult.ExecutedSql;

    // This code is needed only if there are database assigned columns.
    if (dbResult.DbRecords != null && dbResult.DbRecords.Count > 0)
    {
      SetAssignedValues(dataRecord, dbResult.DbRecords[0]);
    }
  }
}

// Gets the key columns if there are database assigned columns.
private static DbColumns GetKeyColumns(Person person
  , DbColumns dataDefinition)
{
  DbColumns retValue = null;

  // Create the list of database assigned and lookup column names.
  // This list must include the database assigned column definitions.
  List<string> lookupColumnNames = new List<string>()
  {
    "Id",
    "Name"
  };

  // Create a Lookup Keys object with the lookup data definitions
  // and values from the data record.
  // This is the unique key to find the inserted record for obtaining
  // the database assigned values.
  retValue = DbCommon.QueryDataKeys(person, dataDefinintion
    , lookupColumnNames);

  // Create the list of database assigned columns and updates
  // the key columns.
  List<string> dbAssignedColumnNames = new List<string>()
  {
    "Id"
  };
  DbCommon.SetDatabaseAssignedKeys(retValue, dbAssignedColumnNames);
  return retValue;
}

// Set the database assigned values.
private static void SetAssignedValues(Person person, DbValues resultRecord)
{
  Person addedPerson = new Person();
  DbCommon.SetObjectValues(resultRecord, addedPerson);
  person.ID = addedPerson.ID;
}